﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;

namespace NCC_SOP.Admin.AdministratorOnly
{
    public partial class viewAuditLogFiles : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {

        }

        protected void deleteAll(object sender, EventArgs e)
        {
            string connectionStr = "server=localhost;database=ncc-sop;uid=sa;password=lifebook;";
            string sqlCommand = "delete from auditLog";
            using (SqlConnection SqlConnection = new SqlConnection(connectionStr))
            {
                SqlCommand cmd = new SqlCommand(sqlCommand, SqlConnection);
                SqlConnection.Open();
                cmd.ExecuteNonQuery();
            }
        }
    }
}